SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012298 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012298 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (758322,849346,244910,765039,56744,318694,705047,754151,505510,436627,739490,28468,398211,132947,1048479,822155,676155,169821,1020268,244294,859258,725056,49913,867550,856957,878330,135187,328715,265740,105473,972677,839230,175240,281595,763553,419594,577427,541967,630367,738558,212467,478885,415851,704868,817237,809612,171104,736039,855607,9342,992515,420286,913764,884991,850534,658392,549732,201279,200343,820538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002827s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012298 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000691s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012298 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]