SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001704s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432131 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432131 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024309,920933,451934,1019280,586162,183287,897436,489826,371895,143191,468059,1008886,172961,852041,775827,695917,502344,484880,1027531,292773,44918,287216,936006,34654,551152,151106,550193,947195,894646,179211,690759,543260,415985,566851,809433,450897,466311,936637,217906,9835,754406,913106,131940,467731,648924,265469,373109,748665,1006679,750991,140278,222327,648902,411394,409758,369051,340822,269757,518731,786703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]