SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007819s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018823 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018823 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492538,101180,374257,638072,952051,557070,508192,915741,556320,905563,272985,693415,294275,657301,481943,546017,772789,567620,112656,742489,50248,46581,513113,254620,418144,162420,3134,887309,197546,383070,214040,796652,523498,901226,625846,216923,269435,972983,372278,890401,496154,814976,575913,49137,883364,609617,889947,800032,848833,755091,97008,718616,482514,310205,308718,639609,324451,755034,732348,183299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]