SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445923 LIMIT 1 [ RunTime:0.000664s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445923 [ RunTime:0.003072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443784,75331,877672,351583,739113,382004,483259,98631,742100,764531,175798,89374,32083,837517,720927,270139,73624,461028,213898,478336,668250,677623,750250,842223,83161,683867,402550,59554,937013,317819,973602,387882,678203,597215,793655,280452,248449,947705,119110,640104,661357,881533,454463,120202,726596,82881,1005376,505813,350210,65515,25281,431040,81707,62712,675364,801501,784336,271876,384143,799301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000838s ]