SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511036 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511036 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557318,909101,300136,172763,201258,650398,244944,210734,933418,783545,903567,962432,916026,538029,237235,434889,485355,995134,345417,550903,671311,496245,612776,1003022,827873,460370,64939,50615,171434,408584,643254,584813,930426,1031578,626127,275165,959112,865483,993927,12384,361305,180549,581983,673523,217462,6564,955886,940737,198429,977148,839807,771859,1014875,856746,310164,353931,987872,1022082,698102,963267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002911s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003179s ]