SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567316 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567316 [ RunTime:0.001424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29694,208151,118117,488470,386755,926136,555058,869489,950188,851432,817711,914365,516821,1029040,649468,650196,66443,1033035,126922,109451,483013,922621,423570,776388,828704,557707,709627,907693,129709,312294,321570,1009873,959574,439769,586585,197016,570880,237059,872145,898972,277807,543914,318142,376577,456384,800055,733617,554657,252491,977695,562550,528405,843630,92562,613272,46439,261676,519617,490055,876827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]