SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417740 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417740 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340090,409228,24186,813918,182146,504501,768335,987743,660259,31491,523692,865660,702935,867862,953244,740341,887073,648879,691611,476167,604208,994853,683212,251394,1039133,212120,602632,42201,819169,210191,883747,91681,519987,634198,474335,115048,971662,769876,869116,602894,525618,407651,215033,892455,528839,200972,135203,913073,664822,958000,994408,370947,1003381,275410,780380,791602,836888,365533,536506,564832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]