SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001797s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501510 LIMIT 1 [ RunTime:0.000656s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501510 [ RunTime:0.002368s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316990,666808,809717,702955,952041,996352,150548,782372,887545,210430,781930,212656,711081,157869,731105,412787,1035919,712414,828194,264823,36574,569989,535960,17505,328230,25919,777284,511806,147268,413313,717645,307757,743378,606001,101002,853479,884324,140122,255865,555464,325266,972249,988279,261861,845123,229086,115378,977747,555514,368196,821901,19869,725836,1046371,513608,287147,356121,674207,21496,824039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]