SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 602009 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 602009 [ RunTime:0.002280s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748254,930250,559961,386817,291451,168838,150274,551761,470785,334606,669942,101290,338776,917770,698859,419589,443700,445080,82327,948554,382621,225469,25014,127937,905688,937943,785211,269669,104156,999859,811588,524653,889776,948241,942390,601778,900317,671539,67580,910758,440835,64540,554794,531247,804754,133199,425341,764179,845210,257370,121971,135667,483521,305675,77387,925366,401843,598594,785802,197676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 602009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 602009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]