SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045075 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045075 [ RunTime:0.002415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364811,159771,173741,649345,127120,375050,625210,529930,859252,525706,3421,283342,753891,143387,96290,745743,439239,299117,315221,228429,812629,471099,171461,430031,146364,586869,380921,395725,843844,964296,869608,134307,210608,919820,177050,585339,1007114,314192,849130,990990,854435,398929,233354,664834,483283,360421,275376,160263,845456,345860,477484,215418,425756,1014209,934668,256530,508916,259386,81057,582055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002530s ]