SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328537 LIMIT 1 [ RunTime:0.001229s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328537 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550209,615963,259679,127209,429504,805991,126291,266843,414345,71869,1002938,518863,122413,963837,310685,993029,124111,277821,350307,159538,823949,339222,107907,139981,524405,682041,1009422,114595,449801,953707,512163,452545,226553,180292,826795,915387,89239,735313,108638,602783,746525,420715,296554,783205,148032,185156,327286,289754,234003,901338,93346,377175,48244,655126,21247,901764,1000961,831012,241172,107496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328537 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328537 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]