SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 125064 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 125064 [ RunTime:0.002562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371944,1014576,350847,610943,287323,5874,911986,1041469,476609,169236,159261,765757,206455,261544,149625,74247,389180,1020529,779464,941512,423398,612970,627409,879555,281750,393694,94684,442854,528178,826506,794349,720129,440578,1027943,306152,76717,733688,722723,989334,1032213,108180,288297,704165,220830,349030,54269,406637,963423,293822,618423,371884,817344,815808,224753,282344,208702,201724,518255,752040,293148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 125064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 125064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002352s ]