SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326541 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326541 [ RunTime:0.001902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619856,213581,740365,146452,664686,40018,786391,648151,1002062,470462,1011333,213316,760028,682773,687257,365169,174923,787959,1004482,733524,958218,1001416,461291,553420,192647,481473,106604,7301,1019425,1009000,281088,117570,566382,378573,335169,818468,54227,320944,196412,718949,655845,143886,570252,420191,99792,835714,785212,669828,53020,578606,1009646,19311,69821,872286,586633,124211,345407,33473,852795,593656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]