SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546710 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546710 [ RunTime:0.002050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522119,813341,343410,468245,996206,971764,443987,301674,524053,903039,768874,89631,980928,178931,908651,413182,157824,648496,1000933,366133,128513,1006137,464681,142709,349043,56436,201577,682232,305823,199344,795588,798403,331150,679357,473837,280688,120020,818081,465518,883059,651801,370968,657732,683173,714024,503362,1038562,771311,979904,247223,863179,436400,1008750,609951,231679,545698,591926,689846,843040,817912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]