SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437711 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437711 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846939,710189,243928,1022205,724852,693263,778548,303806,455805,128782,904518,536085,799485,631272,896508,196040,373519,993643,275525,1037274,804320,514381,291798,471371,1026990,420470,793327,696006,802489,631169,1026644,179296,650454,389726,934026,1015785,691959,293941,607059,204017,353741,491839,706251,627601,75421,134965,526611,211213,1040169,491558,168187,374884,522122,508182,620452,855201,777198,956285,392740,62204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]