SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39435 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39435 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566271,744320,1036127,300337,36636,507382,537315,546839,834910,230717,432001,628908,721357,982539,206926,52092,994202,405154,305275,219416,897474,148286,369760,414713,882861,364814,196526,137652,480480,656758,479043,759210,553080,604108,395737,474827,319509,74454,679589,324004,569253,424756,432729,266996,905762,952056,958083,563891,940865,58702,575882,482362,66296,130931,660204,739817,462694,827552,286081,741730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]