SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023387 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023387 [ RunTime:0.002335s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50334,526335,310341,737469,935480,867261,802972,563610,1033502,31002,60269,231568,952737,255243,986057,620042,1038058,948864,861110,639707,997034,1027116,1032158,825571,616965,19883,575774,657298,255432,1006981,828897,816547,510900,702532,645929,866021,698857,468774,1000256,736389,663480,489004,217837,796860,956934,138707,891131,990243,842411,99059,475564,428523,435195,1022439,792325,175932,763087,929159,999787,697432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023387 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023387 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003894s ]