SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68170 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68170 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403698,1032863,831342,583267,418276,413941,979304,655544,1024910,556834,374520,1028160,540094,786280,284810,920265,140257,693707,723163,927597,1034267,209621,933546,523244,830868,384186,967081,328856,73446,600613,617778,836856,773171,804069,723458,1008316,950163,151764,44357,120400,360907,877840,125118,1000025,107625,424874,937631,854661,841601,845638,578321,502315,849646,602276,218258,672057,527370,486419,686756,115096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]