SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023489 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023489 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315930,89665,803789,640220,828403,469402,58838,476294,1048391,250039,69836,562400,895278,588222,352942,721832,842597,778910,423772,865437,303869,916997,588985,116222,466953,311741,824555,60163,885220,898367,19380,827198,319875,731042,22555,662289,525453,498719,699633,145342,132012,611002,684807,957051,771161,612603,568891,470570,204068,538854,141097,186538,905744,1032579,408674,838119,116089,751110,545465,1036084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]