SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012063 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012063 [ RunTime:0.003419s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113861,473906,20626,871960,90517,822864,711620,925792,245893,1026707,981629,994149,844472,531111,187984,390693,244505,448479,779743,895120,1018484,166840,202641,204119,998895,535162,840379,847459,133094,456509,871436,464809,140762,157959,944529,108773,19265,288499,298631,336347,310138,240936,132235,68503,37055,578561,779669,639869,624779,631272,141946,872375,181313,31556,1045060,530776,982322,468977,624630,798099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]