SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391318 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391318 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005555,1019958,507965,679092,675127,757663,69563,194826,713452,995659,675060,543394,190437,1027078,523969,601775,99844,295089,939996,60991,531997,232926,992980,627189,650733,607404,657058,798980,546667,818826,883190,806864,142918,249372,512624,181364,698145,27430,802612,819550,7639,761431,395788,3413,764208,837435,1026014,609929,479984,835059,888778,465852,747905,5123,395802,80284,715493,174133,387162,348312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]