SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001653s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685335 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685335 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348829,860340,445468,287386,453259,228551,54645,613272,789798,438966,36716,1020857,116369,216880,102909,322247,599326,1028027,288222,702541,569096,263330,382478,722027,192476,334832,385539,912654,574624,750516,559388,145341,1026616,356205,549045,929972,331367,1026033,122965,986230,590535,52213,192027,1016559,217225,302178,488113,208608,398574,996177,994114,948556,1015282,496566,14377,523927,984682,527413,975519,790317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]