SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030639 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030639 [ RunTime:0.002146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160524,513039,727905,515088,444402,800352,103077,166580,423143,549789,640686,10139,248858,437733,42401,701746,577476,848889,44929,372933,728036,580930,124870,897710,624429,457765,55215,3288,766268,183593,845030,378601,16454,643113,776132,499020,565801,456715,380338,803347,152532,310948,419595,921251,320049,361687,977846,424497,765504,967451,198900,361572,486198,530015,447380,147171,450409,741446,780876,998401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030639 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030639 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]