SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50484 LIMIT 1 [ RunTime:0.000985s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50484 [ RunTime:0.002609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (669079,696944,1027927,398505,699167,859241,141074,836335,366956,456105,533636,415933,837965,470238,859224,355876,789165,177800,686208,754731,724667,924132,841681,155680,768963,682775,554097,688133,826424,534353,793888,390757,298286,118371,448665,553152,224011,604423,413749,447570,59586,4950,92909,756224,639467,339139,838115,1032561,672234,825061,946360,216816,160878,677905,709741,705486,137216,929180,315402,358210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007879s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001747s ]