SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459419 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459419 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36522,12943,306931,22304,818942,1015713,181537,797630,751555,1022341,644833,741573,330942,912240,293247,990601,887329,194779,109241,534782,1028480,856667,885872,257025,753164,16821,944830,836072,558673,993813,192635,458678,338777,323352,988502,571477,194018,310230,507601,318053,407707,757336,333906,245639,922337,853979,184305,425005,68528,250245,156247,880258,638464,534084,282370,654034,22142,586192,770572,4997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]