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` = 9303 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 9303 [ RunTime:0.002096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531083,1036255,1004099,352030,897078,173831,1003440,671030,1048748,334320,786170,629826,648404,562213,871810,198024,126069,151791,20914,827644,1015539,694566,785186,1035903,632702,1026175,644766,215356,789572,378435,883202,838509,269597,561320,744100,389239,857539,176866,760371,89199,817579,618496,701049,612488,1003921,918990,695907,310399,802910,150906,392069,963732,503439,307030,832226,1041072,284931,990083,673648,794238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 9303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 9303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002438s ]