SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422596 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422596 [ RunTime:0.006663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040046,728803,862062,124526,380227,953477,875070,469064,443068,263467,425937,499543,67355,695351,733429,605864,633401,795466,87714,926383,546783,600721,102970,338813,430087,618670,914856,650253,709224,673930,1012272,192253,973578,9852,11913,28469,202865,493005,78543,928131,224521,905175,414360,461413,484633,861451,659242,844167,479834,263119,109489,556920,312846,451959,402461,374007,149125,525184,141105,409212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000883s ]