SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001834s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473641 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473641 [ RunTime:0.001911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853802,777617,891896,1004067,784562,760551,744823,811229,1008493,1017629,471328,340399,715740,676761,91379,40904,1025210,569774,268895,495579,114055,437608,167740,289835,89925,759024,781485,449935,1009884,871552,35364,165197,46346,78933,235057,185403,362789,390790,1030859,172910,213998,515,760559,972887,396447,941013,292401,668779,1004284,161848,1002834,756838,743990,444143,822718,842415,243776,803423,203587,202462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]