SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043806 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043806 [ RunTime:0.003207s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864283,465782,339516,529415,100040,592333,42175,32232,667912,669240,890094,17602,965167,1016287,292097,95386,952306,72064,113016,522650,641709,430885,789772,203138,728402,674324,128316,1014175,819987,507037,150498,273286,982224,379013,60961,415326,293349,991524,897220,71565,909365,70550,4422,540664,180073,744739,329050,725612,11985,238234,250038,163390,294653,755458,680423,399159,467511,1028030,896789,812329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]