SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457922 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457922 [ RunTime:0.003780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235140,817127,902867,153063,397560,549434,964736,378698,940653,965736,104825,790379,914876,471018,1012748,496455,637677,19597,700197,770680,460711,799798,771126,923313,336854,627096,306290,631931,849427,678555,197538,682710,447777,755481,763366,1005829,624894,726943,4231,37349,222854,1030953,1044614,849962,317724,949943,271850,228952,38857,57452,61976,368383,418193,899392,121741,403497,294539,579646,161661,190916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]