SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244104 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244104 [ RunTime:0.002456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208732,713117,819705,38967,542753,912840,124584,815549,954310,153614,367727,751353,784273,302744,340124,289480,20927,84013,797118,375132,311749,45823,509776,217511,442353,275598,872013,938111,171318,937068,1034346,814305,126051,46469,917830,208294,777190,227001,869526,142913,939976,171565,976341,235167,65909,112876,171513,844174,217178,136157,369434,278034,583212,671710,917645,246263,375583,11443,716175,309684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]