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` = 1003138 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003138 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625155,384086,980570,56755,130312,356391,639509,761999,9109,575235,57906,506144,11872,900179,1041237,118199,724451,686655,45659,956005,28099,949332,556016,578275,243338,1021361,887320,63695,811660,451895,917236,349853,321193,408193,116331,939922,248163,282683,283102,184704,661829,244573,1002975,587010,609395,611043,464651,44901,399491,787858,323614,116150,618794,49277,729141,355964,366774,385633,863275,222018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]