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` = 268240 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268240 [ RunTime:0.002568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663213,556649,391835,105813,966974,1003254,187759,318256,486188,611214,343709,778295,128042,857974,847834,65725,1034554,410498,1048192,998282,457170,916197,335458,354154,813297,685630,496665,352314,91385,227670,839586,495791,285187,911101,742520,233530,123593,961411,884762,668722,270505,435427,943377,102275,48886,65230,281464,165542,989402,756283,238121,174143,64348,152149,542855,524949,841831,560425,797595,276312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002097s ]