SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300616 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300616 [ RunTime:0.002155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375510,790186,645377,57274,686222,44276,912804,437085,54190,110467,718673,248836,825456,278543,351820,978280,271556,428836,722225,709604,392492,49291,181430,449753,475834,654675,579078,182939,57206,462491,967254,341999,892209,314776,424903,834873,806616,114299,76798,273616,50137,464095,452052,989501,462608,579722,529213,338274,589548,633913,752302,237924,764379,750529,544384,284163,309742,8290,789043,836650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]