SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012594 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012594 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (770548,709775,974060,467100,573382,134510,423616,373909,363673,188353,460001,442495,997786,963332,177205,529017,1045706,412386,421037,780328,111338,94204,864270,258370,885010,187078,551436,243593,667917,734775,504166,384541,691205,684533,460860,584723,13290,683415,86298,612233,197107,427459,1190,639122,586579,595314,252009,165470,554742,904725,800635,913338,307175,866743,664749,740346,641754,259893,628334,990557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012594 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012594 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]