SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405101 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405101 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6237,631443,899298,1022573,423266,315781,620630,456201,687920,25700,130707,327063,610629,682332,115710,906437,279963,786295,737845,464430,122754,81315,389915,808785,118026,1028930,735020,807940,774674,26928,468415,142401,799759,560978,210401,440175,509721,565802,465686,958549,720723,331902,468539,236850,558031,374883,300937,587039,728022,390807,502078,532866,281225,253474,860092,602869,836096,855247,89696,394229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002685s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]