SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 124104 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 124104 [ RunTime:0.002482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674833,69434,575771,80240,555943,819101,849212,971105,564349,269001,230405,823431,1023559,532082,736358,419805,694916,79700,189091,504732,784547,383029,541372,239665,739634,794467,705483,628817,401407,278141,341539,993735,239502,822259,28210,193657,765348,399803,937191,917632,574237,902321,288754,151314,527016,115597,694694,70078,1004641,138105,46109,68224,486760,248363,221382,272182,942384,213639,75484,576910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 124104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 124104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001370s ]