SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806711 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806711 [ RunTime:0.002696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676144,756072,586074,845955,215549,303910,678300,39897,109359,412180,368454,683188,246100,111417,226999,318157,624647,191396,754546,846688,711576,825424,699483,936355,432691,234041,563697,1484,1017594,559934,277043,836044,648044,436313,633253,121112,715910,208953,145347,354384,413570,640681,708777,842722,123652,674980,238898,204553,991672,441604,37456,965658,292863,953490,1015809,815440,570873,866563,925066,1034269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]