SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492914 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492914 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301286,902866,893037,479256,296332,56451,1015419,656970,189698,587751,387438,293422,278395,938757,54793,849512,283770,841884,1009202,278299,392018,82756,951080,749890,820167,913788,316979,757635,543351,67365,241788,147325,952679,580762,896227,769962,528107,276140,621360,364554,381130,516686,438090,562180,551211,544935,335776,292446,962851,311068,1042276,479920,830878,292867,226241,480604,483623,465342,861680,876255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]