SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200504 LIMIT 1 [ RunTime:0.000584s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200504 [ RunTime:0.002986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (74188,69373,195670,323320,162777,460130,452819,9737,38877,869506,116696,561876,126783,50433,491247,469769,215705,475659,186556,814849,790313,577051,347423,100846,935280,904522,118724,457734,618818,219325,667575,937331,1045151,231411,623194,441581,782572,826228,531062,806353,452756,59881,673295,451591,858566,162726,764228,164686,721971,365150,318021,83219,474831,225580,664283,166784,232663,416347,51918,211725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003895s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002498s ]