SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591938 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591938 [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98500,862790,229000,246272,925319,611760,668530,355412,120761,351068,683682,429271,115412,103229,55026,769641,926524,425833,852041,782902,125667,1028545,519594,514212,460710,353966,256282,168880,473863,624243,196625,593371,864914,830056,539564,451215,997700,1042413,88778,701703,985872,43234,371704,33032,551376,79977,725770,179600,206749,886199,328093,407146,550443,361689,561248,1048760,632034,527135,929431,707265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]