SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201238 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201238 [ RunTime:0.002521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881047,90985,717820,266661,279110,191585,78521,703938,668344,211813,125602,215550,269543,521615,598377,462619,257110,690035,492231,8029,291178,944905,978755,15107,1040296,358926,984376,697935,1019984,63897,226751,435944,505659,770383,402953,676111,299167,205569,527266,385578,315160,253921,1034206,413688,773023,781462,68308,867823,18299,11448,160484,927801,719275,406090,341475,283491,411268,575296,1036033,198374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001079s ]