SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517307 LIMIT 1 [ RunTime:0.001828s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517307 [ RunTime:0.002572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (933088,894064,1018417,1032610,650584,26948,140832,279936,797012,387935,326575,302185,495009,329134,701927,415678,1010982,502645,336998,449793,755756,743675,819229,369473,597629,708147,806688,584215,439742,1006537,275256,647913,722742,650290,2803,173758,306796,1012084,164709,588707,105008,806380,50918,61064,139865,732221,940083,599620,500295,317369,660322,565058,86066,498727,876399,1020437,20859,407576,835299,338982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]