SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504578 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504578 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180191,951850,255188,740867,44177,68670,554070,577125,887288,770393,460456,483608,273741,575764,354275,341996,557875,819893,804117,114561,778944,1035127,565359,1034349,958383,73584,699366,632878,327532,767256,992383,625851,270204,324646,1033058,662795,797824,424307,1019730,264395,487312,544009,253465,601340,115382,799893,795132,185877,429974,522323,489857,946226,313401,94152,851975,759913,973394,960896,401532,191247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]