SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469470 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469470 [ RunTime:0.001940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607397,1020119,471174,715306,513733,249363,867130,698690,98368,159759,470310,176503,1038969,26638,404287,831989,1004861,853607,128926,1011008,739306,167689,625000,278926,666475,551430,869369,22217,853240,798726,558137,625506,9985,990725,531239,253221,904162,82498,928449,819893,870058,446997,230511,1009284,692654,652002,691138,681872,717034,167583,103449,851190,701975,14908,34921,713913,785824,1025375,944740,249328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]