SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319004 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319004 [ RunTime:0.002299s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13495,544486,24529,566480,813814,981905,470748,133650,704396,106534,4832,473519,540846,163262,149641,372821,441197,430451,633172,441953,876997,893655,743427,32030,309230,84795,420804,754205,723648,988690,179116,353946,514162,1020190,425409,680837,782710,765013,497390,446215,71290,795581,357916,571317,466896,61383,304669,253862,775170,175853,386436,354749,8614,273132,139693,509297,319952,45077,80813,255305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005809s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002956s ]