SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025623 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025623 [ RunTime:0.002081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307327,352752,945032,862037,792593,447421,275540,808521,39257,487600,29777,660259,869034,443957,15505,592127,158689,671226,844181,994553,565188,896839,761633,851206,267474,722737,375123,786727,306795,667987,59761,1011927,487229,226222,640800,695555,715103,987569,641963,698432,524974,229213,514053,71270,936479,730889,801395,579473,924820,216359,901655,298380,773582,715561,502037,774700,453508,708704,554319,1012810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]