SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255306 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255306 [ RunTime:0.003074s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035604,474613,109321,698511,500614,115629,329590,648600,519112,229214,139764,599441,478788,284066,694037,934783,232428,874510,105970,267884,709627,162618,917851,845203,817180,883953,323492,348227,537803,169323,924911,539765,1004701,151582,517975,88238,68019,721203,810766,187417,607806,388220,408882,44006,204464,504493,943427,973420,330548,58746,826705,753602,597820,827838,69419,116335,347645,650534,991686,512891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]