SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 592918 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 592918 [ RunTime:0.006085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396059,414789,219612,22366,795990,271700,376915,48932,323227,938532,17178,336133,950434,210153,663613,554004,136468,943018,611277,303185,737933,200014,68857,136673,24539,752126,612519,545914,93140,636140,348227,758476,200027,1003289,539559,642453,829230,1004914,686167,1045592,553019,1004062,600347,190249,1008387,352169,255770,411466,972323,759662,348200,461569,882975,313192,693574,539455,392654,666949,431268,833228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 592918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000807s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 592918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]