SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018122 LIMIT 1 [ RunTime:0.000661s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018122 [ RunTime:0.004761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122569,6986,309463,476517,294833,462706,853043,312513,278766,606592,248854,987079,609575,380100,480906,517331,448539,972270,492851,79779,772835,555321,741585,336292,844939,79462,671297,500781,705171,72181,369684,259316,619720,783404,467482,213319,488090,740466,450064,842927,514289,929458,44691,867234,586318,191671,280856,360976,598275,625302,477547,87311,510088,872733,495510,95962,992249,284417,944566,942566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000909s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]