SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 123283 LIMIT 1 [ RunTime:0.000580s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 123283 [ RunTime:0.002925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714800,434409,784547,337269,798328,200509,363182,180989,72008,654497,873310,92188,416139,544540,53246,129977,263826,652317,214051,775403,558555,543282,832961,37484,682066,317135,933419,509795,357340,853356,848529,588670,394799,390146,969731,469919,689120,255228,1005813,831242,975259,150140,435925,789588,591519,846240,174675,177625,525916,17570,428031,225307,166916,236846,847810,790488,284734,982051,211892,420318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 123283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 123283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]