SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476499 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476499 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (650420,500673,1047261,166143,997185,874039,303355,854081,18443,369633,914751,803581,344378,552171,819484,604513,20126,604731,73814,583928,704993,682064,806565,461245,536878,319763,11013,535832,538874,723285,819595,867843,868695,584084,614405,730054,107845,752375,942701,710699,1027576,237600,79075,182114,527427,24643,596052,805026,892281,412901,955504,346404,10241,859436,385278,326587,35986,783917,633722,60449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000397s ]