SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42204 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42204 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446816,268756,397459,1016900,382342,265086,57642,466057,434629,733805,763694,608926,690541,412988,666068,401675,271796,63956,1037006,577594,718754,579591,902873,309407,871727,213893,628644,992184,218017,755137,436475,719783,879580,183027,111620,556754,1012172,915727,1042136,913209,740784,682954,1029147,79747,395752,878347,13673,23592,705028,328291,183815,917557,894971,647767,623066,632617,427437,699180,134885,28907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]