SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541811 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541811 [ RunTime:0.002454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048437,400746,652491,364036,479603,974284,201245,818459,185730,795157,314485,345095,294560,468891,432692,235461,902387,63624,140344,84723,778114,311308,379627,117074,718033,831147,188109,306854,288748,135404,606621,456671,502129,462482,352033,261834,189195,862015,884504,930213,301030,758627,576788,25373,912114,945279,846458,1031772,11193,960588,998920,402503,812701,1046478,281566,400029,457313,872445,378062,772577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]