SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507293 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507293 [ RunTime:0.001417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136177,866645,378041,980103,340314,121292,556824,308355,467107,368554,635824,847378,179205,745630,680825,395491,921525,600106,607989,664230,104002,517517,319202,301613,75675,762319,944183,440105,208920,411511,938022,122743,994430,832302,945515,840437,433518,881875,1038429,979645,929173,434564,507312,55790,319261,394657,1035501,657379,912858,817047,243193,710354,492957,400880,423167,1045227,361894,365742,61045,124993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]