SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201733 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201733 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303422,365800,302355,210913,303677,44115,863781,96973,648791,1042149,864317,575582,763577,624771,825330,604935,961505,774989,908415,553554,564778,564553,265999,35898,276158,735599,582996,318281,960452,524139,399978,345705,195492,86454,473023,584986,340214,620917,330954,3410,889131,151512,804283,44480,446592,32370,614736,1029521,393661,381754,22892,715036,114005,566471,861503,769881,291159,22209,213578,578204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201733 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201733 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]