SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35152 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35152 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481229,33112,838405,219829,826908,272204,518137,453974,130749,884499,665376,167904,343420,834724,828282,59989,308183,296363,5539,882490,248082,703929,915132,791850,735386,895637,568199,405551,357217,586753,657114,953502,877860,715836,258419,630672,321022,244336,256900,67980,312079,456151,200890,274324,836348,252868,521983,330274,902555,816002,350484,450690,800773,418760,613335,989535,981084,602351,710703,330577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000817s ]