SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014435 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014435 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206004,803339,778813,477691,32146,950527,14401,191139,344085,1017930,98272,1021029,214255,382959,402246,630472,1027407,466796,883363,537737,146214,172885,867849,209839,788356,847949,149354,1043302,36696,45616,799266,867441,89542,766328,247588,185854,29687,10100,562533,435910,267352,183562,228644,363669,541622,425337,684433,507793,18761,145148,848792,144808,443438,1013627,400929,445974,172404,333558,820295,1041976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000390s ]