SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031366 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031366 [ RunTime:0.002924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575603,861954,361014,606240,412059,38047,492810,418126,30382,165527,385492,505893,878397,269158,465240,462289,423062,757625,426629,307515,267902,1000456,815195,334608,335800,853230,457892,18516,407169,340402,244311,240960,113146,374146,682911,840450,841528,718155,723299,466376,298703,679465,497759,882415,611394,375689,997109,1031427,567068,419665,609603,279410,25323,59554,406218,925819,908909,904149,111058,1005887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]