SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014617 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014617 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940691,908295,85834,968793,87014,474717,446791,615049,804326,659873,359134,379076,203341,500140,268188,345648,511909,774856,797723,703081,760248,425642,222394,97583,319425,351584,1040019,914970,190284,681077,928786,105520,882354,196861,373407,184940,120328,698049,329545,615891,1006795,12950,637335,580049,430269,908098,148196,751461,1018490,7548,672984,24407,955157,889376,294988,804430,787343,184742,2766,704288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001278s ]