SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001829s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550841 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550841 [ RunTime:0.003100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979782,555232,788369,944618,222383,194550,866102,216404,611621,754612,246064,505472,491496,195187,942529,133666,960044,748970,1017154,120502,9010,261376,883357,584885,754268,912895,959282,207098,1012661,933205,1007686,422544,721570,141258,823143,280392,365419,273871,453505,516750,211184,621492,351667,98750,579020,300793,161513,131423,1041590,256342,959568,823593,455300,443210,307350,224556,614660,589717,944562,692802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]