SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428162 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428162 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332086,679148,501400,300863,216382,824640,503157,1046379,376933,260078,274033,738746,165810,273973,384512,487230,396091,444,234058,238578,502450,560143,346726,584974,876534,180924,722827,348970,124051,108862,445899,401118,931937,421279,639217,36037,567795,369489,245260,773397,112864,1016177,130675,502822,280506,375862,593988,584568,16009,712948,61162,390604,474925,714562,885502,269408,184260,803755,243144,772019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428162 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428162 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]