SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107660 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107660 [ RunTime:0.002302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509393,812304,947695,257408,984233,326157,755064,736866,67386,486104,511239,46105,17884,659800,47478,506282,43572,1002583,449243,415385,872331,668257,639458,361577,423943,44151,82131,709427,158110,769856,219934,803091,922437,425587,420972,223879,592585,570265,564936,340471,303764,580301,922207,390860,588518,762113,760581,55440,394933,30195,97115,295349,881403,487146,478887,460049,235970,338912,628187,999611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]