SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421026 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421026 [ RunTime:0.003054s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759019,925038,555718,714909,391170,901894,116609,442059,263847,651029,495017,572058,649280,905575,840965,221372,376907,18102,997897,378149,847133,410942,11604,796410,652914,47408,388246,211475,238190,26663,12136,178114,412733,711023,82456,303236,78055,523202,280016,843472,151316,162689,877669,196060,230673,192206,641383,349093,996749,1042571,746456,715478,1031956,389602,366122,187380,47127,823149,403604,700514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000982s ]