SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002437s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031090 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031090 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458717,449559,360094,942755,148312,513518,656911,294767,760357,866028,393575,843137,610619,105525,636875,51808,637152,447598,761754,119632,292243,660629,778989,169686,917056,92808,917660,700496,706797,625644,783496,333498,1038659,744307,441451,972094,70953,704609,653474,83049,125109,240715,738187,39639,315105,1019366,213763,419431,284338,102479,803051,420029,541227,1032276,770581,764790,448482,647599,185463,574220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000380s ]