SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317975 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317975 [ RunTime:0.002770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280034,800844,192761,146185,736574,747306,209974,658881,80143,33612,904473,569382,534643,849747,539668,155276,359759,624942,369050,763169,743830,639068,728230,286787,243396,633875,435215,905693,726119,910240,362260,333697,807355,815135,603336,1023186,493105,321361,383205,688303,691944,707192,3028,5396,790485,511381,991362,466434,1037364,412556,799283,414603,792935,725260,1040390,983704,688888,609113,496439,945851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]