SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402205 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402205 [ RunTime:0.002543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70067,659030,106180,530407,804324,805873,269639,554053,507999,183535,65781,1039950,25132,802940,778998,565310,1041334,707888,444733,573672,946503,602132,721560,775274,6968,585650,123313,302964,305880,329141,697637,825494,613794,496675,355386,371034,819753,949756,380111,392238,256677,357076,161322,604128,401879,247567,1038045,97776,11542,452911,518112,71407,16523,71074,790640,262810,854551,554625,205299,896196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001662s ]