SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001016 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001016 [ RunTime:0.003172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3588,666894,346173,135533,945329,912314,639539,113380,103604,560639,319531,19282,819813,223892,109392,615179,199704,332750,927544,226783,141507,139671,866837,433118,1023685,724606,401047,373189,920030,74011,506583,646409,30955,105174,767817,364212,678542,516188,385171,986200,787049,733727,484664,583132,163239,149177,214751,982217,124171,15915,851450,293283,310016,862369,387653,293978,5690,423775,587839,694279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]