SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291691 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291691 [ RunTime:0.002153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529591,542057,890991,87951,621639,42969,515927,830140,739288,116108,438789,314229,233333,901534,46244,794420,465315,261685,198665,1033701,649366,555192,545702,1010673,912037,394893,396587,545485,760439,576307,71222,780528,444271,478961,532688,582712,166183,568637,929902,830478,84542,17673,219373,719359,543411,820618,242490,735859,439101,366634,1017346,1015411,114037,434841,245730,198452,542939,676237,724003,128583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]