SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574040 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574040 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564649,432742,595038,199079,1000964,131148,874033,376279,464641,873895,307313,429673,549489,851665,100797,382867,913203,411932,803077,531873,885256,908863,410790,759965,764029,402663,35731,694190,304684,619894,814680,1021219,651773,1002615,260475,905735,177610,136449,268105,232742,616741,304899,646887,691623,1043477,976040,1046696,357640,553007,716682,843036,883620,104530,803354,539209,227430,65541,323005,793185,134899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]